Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\cubes>cd c:\xampp\mysql\bin

c:\xampp\mysql\bin>mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.5.25a MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| b12joomla1         |
| b13                |
| b15                |
| b17                |
| cdcol              |
| cubes              |
| imp                |
| joins              |
| joomla             |
| joomla_b12         |
| mysql              |
| performance_schema |
| phpcubes_data      |
| phpmyadmin         |
| phpwebco_shop      |
| plaincart          |
| search_suggest     |
| test               |
| webauth            |
| zf_tutorial        |
+--------------------+
21 rows in set (0.21 sec)

mysql> show databases;
+--------------------------------+
| Database                       |
+--------------------------------+
| information_schema             |
| b12joomla1                     |
| b13333333333333333333333333333 |
| b15                            |
| b17                            |
| cdcol                          |
| cubes                          |
| imp                            |
| joins                          |
| joomla                         |
| joomla_b12                     |
| mysql                          |
| performance_schema             |
| phpcubes_data                  |
| phpmyadmin                     |
| phpwebco_shop                  |
| plaincart                      |
| search_suggest                 |
| test                           |
| webauth                        |
| zf_tutorial                    |
+--------------------------------+
21 rows in set (0.00 sec)

mysql> CREATE DATABASE `b18`;
Query OK, 1 row affected (0.29 sec)

mysql> show databases;
+--------------------------------+
| Database                       |
+--------------------------------+
| information_schema             |
| b12joomla1                     |
| b13333333333333333333333333333 |
| b15                            |
| b17                            |
| b18                            |
| cdcol                          |
| cubes                          |
| imp                            |
| joins                          |
| joomla                         |
| joomla_b12                     |
| mysql                          |
| performance_schema             |
| phpcubes_data                  |
| phpmyadmin                     |
| phpwebco_shop                  |
| plaincart                      |
| search_suggest                 |
| test                           |
| webauth                        |
| zf_tutorial                    |
+--------------------------------+
22 rows in set (0.00 sec)

mysql> USE `b18`;
Database changed
mysql> SHOW TABLES;
Empty set (0.00 sec)

mysql> CREATE TABLE `users`(
    -> `id` INT AUTO_INCREMENT PRIMARY KEY,
    -> `name` VARCHAR(255),
    -> `added_date` DATETIME,
    -> `last_modified` TIMESTAMP,
    -> `status` TINYINT);
Query OK, 0 rows affected (0.18 sec)

mysql> DESCRIBE `users`;
+---------------+--------------+------+-----+-------------------+-----------------------------+
| Field         | Type         | Null | Key | Default           | Extra                       |
+---------------+--------------+------+-----+-------------------+-----------------------------+
| id            | int(11)      | NO   | PRI | NULL              | auto_increment              |
| name          | varchar(255) | YES  |     | NULL              |                             |
| added_date    | datetime     | YES  |     | NULL              |                             |
| last_modified | timestamp    | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| status        | tinyint(4)   | YES  |     | NULL              |                             |
+---------------+--------------+------+-----+-------------------+-----------------------------+
5 rows in set (0.06 sec)

mysql> CREATE DATABASE hello-world;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-world' at line 1
mysql> SHOW ENGINES;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| MyISAM             | YES     | MyISAM storage engine                                          | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
| InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)

mysql> SHOW ENGINES;







































































































